Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 128975 |
| Missing cells | 210495 |
| Missing cells (%) | 6.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 22.8 MiB |
| Average record size in memory | 185.0 B |
Variable types
| Numeric | 4 |
|---|---|
| Text | 7 |
| DateTime | 1 |
| Categorical | 10 |
| Boolean | 2 |
currency has constant value "" | Constant |
ship-country has constant value "" | Constant |
fulfilled-by has constant value "" | Constant |
Unnamed: 22 has constant value "" | Constant |
Status is highly imbalanced (58.3%) | Imbalance |
Sales Channel is highly imbalanced (98.9%) | Imbalance |
Courier Status is highly imbalanced (63.2%) | Imbalance |
B2B is highly imbalanced (94.2%) | Imbalance |
Courier Status has 6872 (5.3%) missing values | Missing |
currency has 7795 (6.0%) missing values | Missing |
Amount has 7795 (6.0%) missing values | Missing |
promotion-ids has 49153 (38.1%) missing values | Missing |
fulfilled-by has 89698 (69.5%) missing values | Missing |
Unnamed: 22 has 49050 (38.0%) missing values | Missing |
df_index is uniformly distributed | Uniform |
df_index has unique values | Unique |
Qty has 12807 (9.9%) zeros | Zeros |
Amount has 2343 (1.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-15 14:13:19.918719 |
|---|---|
| Analysis finished | 2024-03-15 14:13:37.591335 |
| Duration | 17.67 seconds |
| Software version | ydata-profiling vv4.6.5 |
| Download configuration | config.json |
df_index
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 128975 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64487 |
| Minimum | 0 |
|---|---|
| Maximum | 128974 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1007.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6448.7 |
| Q1 | 32243.5 |
| median | 64487 |
| Q3 | 96730.5 |
| 95-th percentile | 122525.3 |
| Maximum | 128974 |
| Range | 128974 |
| Interquartile range (IQR) | 64487 |
Descriptive statistics
| Standard deviation | 37232.02 |
|---|---|
| Coefficient of variation (CV) | 0.57735698 |
| Kurtosis | -1.2 |
| Mean | 64487 |
| Median Absolute Deviation (MAD) | 32244 |
| Skewness | 0 |
| Sum | 8.3172108 × 109 |
| Variance | 1.3862233 × 109 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 85979 | 1 | < 0.1% |
| 85992 | 1 | < 0.1% |
| 85991 | 1 | < 0.1% |
| 85990 | 1 | < 0.1% |
| 85989 | 1 | < 0.1% |
| 85988 | 1 | < 0.1% |
| 85987 | 1 | < 0.1% |
| 85986 | 1 | < 0.1% |
| 85985 | 1 | < 0.1% |
| Other values (128965) | 128965 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 128974 | 1 | |
| 128973 | 1 | |
| 128972 | 1 | |
| 128971 | 1 | |
| 128970 | 1 | |
| 128969 | 1 | |
| 128968 | 1 | |
| 128967 | 1 | |
| 128966 | 1 | |
| 128965 | 1 |
Order ID
Text
| Distinct | 120378 |
|---|---|
| Distinct (%) | 93.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2450525 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 113532 ? |
|---|---|
| Unique (%) | 88.0% |
Sample
| 1st row | 405-8078784-5731545 |
|---|---|
| 2nd row | 171-9198151-1101146 |
| 3rd row | 404-0687676-7273146 |
| 4th row | 403-9615377-8133951 |
| 5th row | 407-1069790-7240320 |
| Value | Count | Frequency (%) |
| 171-5057375-2831560 | 12 | < 0.1% |
| 403-4984515-8861958 | 12 | < 0.1% |
| 403-0173977-3041148 | 11 | < 0.1% |
| 404-9932919-6662730 | 11 | < 0.1% |
| 408-3317403-1729937 | 10 | < 0.1% |
| 406-9002076-4152331 | 9 | < 0.1% |
| 404-3701762-8241125 | 9 | < 0.1% |
| 171-4310662-2005103 | 9 | < 0.1% |
| 408-2964501-8373155 | 9 | < 0.1% |
| 171-0706521-2133101 | 9 | < 0.1% |
| Other values (120368) | 128874 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 298773 | |
| 0 | 284703 | |
| - | 257950 | |
| 1 | 233906 | |
| 3 | 217114 | |
| 5 | 216718 | |
| 7 | 214101 | |
| 2 | 187121 | |
| 6 | 186690 | |
| 9 | 182039 | |
| Other values (2) | 171410 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2192451 | |
| Dash Punctuation | 257950 | 10.5% |
| Uppercase Letter | 124 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 298773 | |
| 0 | 284703 | |
| 1 | 233906 | |
| 3 | 217114 | |
| 5 | 216718 | |
| 7 | 214101 | |
| 2 | 187121 | |
| 6 | 186690 | |
| 9 | 182039 | |
| 8 | 171286 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 257950 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 124 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2450401 | |
| Latin | 124 | < 0.1% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 298773 | |
| 0 | 284703 | |
| - | 257950 | |
| 1 | 233906 | |
| 3 | 217114 | |
| 5 | 216718 | |
| 7 | 214101 | |
| 2 | 187121 | |
| 6 | 186690 | |
| 9 | 182039 |
Latin
| Value | Count | Frequency (%) |
| S | 124 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2450525 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 298773 | |
| 0 | 284703 | |
| - | 257950 | |
| 1 | 233906 | |
| 3 | 217114 | |
| 5 | 216718 | |
| 7 | 214101 | |
| 2 | 187121 | |
| 6 | 186690 | |
| 9 | 182039 | |
| Other values (2) | 171410 |
Date
Date
| Distinct | 91 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
| Minimum | 2022-03-31 00:00:00 |
|---|---|
| Maximum | 2022-06-29 00:00:00 |
Histogram with fixed size bins (bins=50)
Status
Categorical
IMBALANCE
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
| Shipped | |
|---|---|
| Shipped - Delivered to Buyer | |
| Cancelled | |
| Shipped - Returned to Seller | 1953 |
| Shipped - Picked Up | 973 |
| Other values (8) | 1144 |
Length
| Max length | 29 |
|---|---|
| Median length | 7 |
| Mean length | 12.457391 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1606692 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Cancelled |
|---|---|
| 2nd row | Shipped - Delivered to Buyer |
| 3rd row | Shipped |
| 4th row | Cancelled |
| 5th row | Shipped |
Common Values
| Value | Count | Frequency (%) |
| Shipped | 77804 | |
| Shipped - Delivered to Buyer | 28769 | 22.3% |
| Cancelled | 18332 | 14.2% |
| Shipped - Returned to Seller | 1953 | 1.5% |
| Shipped - Picked Up | 973 | 0.8% |
| Pending | 658 | 0.5% |
| Pending - Waiting for Pick Up | 281 | 0.2% |
| Shipped - Returning to Seller | 145 | 0.1% |
| Shipped - Out for Delivery | 35 | < 0.1% |
| Shipped - Rejected by Buyer | 11 | < 0.1% |
| Other values (3) | 14 | < 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| shipped | 109696 | |
| 32173 | 12.5% | |
| to | 30867 | 12.0% |
| buyer | 28780 | 11.2% |
| delivered | 28769 | 11.2% |
| cancelled | 18332 | 7.1% |
| seller | 2098 | 0.8% |
| returned | 1953 | 0.8% |
| up | 1254 | 0.5% |
| picked | 973 | 0.4% |
| Other values (14) | 2078 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 271710 | |
| p | 220662 | |
| d | 160674 | |
| i | 141426 | |
| 127998 | ||
| S | 111802 | 7.0% |
| h | 109704 | 6.8% |
| l | 69664 | 4.3% |
| r | 62101 | 3.9% |
| t | 33302 | 2.1% |
| Other values (25) | 297649 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1252920 | |
| Uppercase Letter | 193601 | 12.0% |
| Space Separator | 127998 | 8.0% |
| Dash Punctuation | 32173 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 271710 | |
| p | 220662 | |
| d | 160674 | |
| i | 141426 | |
| h | 109704 | |
| l | 69664 | 5.6% |
| r | 62101 | 5.0% |
| t | 33302 | 2.7% |
| o | 31188 | 2.5% |
| u | 30913 | 2.5% |
| Other values (12) | 121576 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 111802 | |
| D | 28805 | 14.9% |
| B | 28780 | 14.9% |
| C | 18332 | 9.5% |
| P | 2193 | 1.1% |
| R | 2109 | 1.1% |
| U | 1254 | 0.6% |
| W | 281 | 0.1% |
| O | 35 | < 0.1% |
| L | 5 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 127998 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 32173 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1446521 | |
| Common | 160171 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 271710 | |
| p | 220662 | |
| d | 160674 | |
| i | 141426 | |
| S | 111802 | |
| h | 109704 | |
| l | 69664 | 4.8% |
| r | 62101 | 4.3% |
| t | 33302 | 2.3% |
| o | 31188 | 2.2% |
| Other values (23) | 234288 |
Common
| Value | Count | Frequency (%) |
| 127998 | ||
| - | 32173 | 20.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1606692 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 271710 | |
| p | 220662 | |
| d | 160674 | |
| i | 141426 | |
| 127998 | ||
| S | 111802 | 7.0% |
| h | 109704 | 6.8% |
| l | 69664 | 4.3% |
| r | 62101 | 3.9% |
| t | 33302 | 2.1% |
| Other values (25) | 297649 |
Fulfilment
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
| Amazon | |
|---|---|
| Merchant |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.6090638 |
| Min length | 6 |
Characters and Unicode
| Total characters | 852404 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Merchant |
|---|---|
| 2nd row | Merchant |
| 3rd row | Amazon |
| 4th row | Merchant |
| 5th row | Amazon |
Common Values
| Value | Count | Frequency (%) |
| Amazon | 89698 | |
| Merchant | 39277 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| amazon | 89698 | |
| merchant | 39277 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 128975 | |
| n | 128975 | |
| A | 89698 | |
| m | 89698 | |
| z | 89698 | |
| o | 89698 | |
| M | 39277 | 4.6% |
| e | 39277 | 4.6% |
| r | 39277 | 4.6% |
| c | 39277 | 4.6% |
| Other values (2) | 78554 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 723429 | |
| Uppercase Letter | 128975 | 15.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 128975 | |
| n | 128975 | |
| m | 89698 | |
| z | 89698 | |
| o | 89698 | |
| e | 39277 | 5.4% |
| r | 39277 | 5.4% |
| c | 39277 | 5.4% |
| h | 39277 | 5.4% |
| t | 39277 | 5.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 89698 | |
| M | 39277 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 852404 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 128975 | |
| n | 128975 | |
| A | 89698 | |
| m | 89698 | |
| z | 89698 | |
| o | 89698 | |
| M | 39277 | 4.6% |
| e | 39277 | 4.6% |
| r | 39277 | 4.6% |
| c | 39277 | 4.6% |
| Other values (2) | 78554 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 852404 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 128975 | |
| n | 128975 | |
| A | 89698 | |
| m | 89698 | |
| z | 89698 | |
| o | 89698 | |
| M | 39277 | 4.6% |
| e | 39277 | 4.6% |
| r | 39277 | 4.6% |
| c | 39277 | 4.6% |
| Other values (2) | 78554 |
Sales Channel
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
| Amazon.in | |
|---|---|
| Non-Amazon | 124 |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 9.0009614 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1160899 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Amazon.in |
|---|---|
| 2nd row | Amazon.in |
| 3rd row | Amazon.in |
| 4th row | Amazon.in |
| 5th row | Amazon.in |
Common Values
| Value | Count | Frequency (%) |
| Amazon.in | 128851 | |
| Non-Amazon | 124 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| amazon.in | 128851 | |
| non-amazon | 124 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 257950 | |
| o | 129099 | |
| A | 128975 | |
| m | 128975 | |
| a | 128975 | |
| z | 128975 | |
| . | 128851 | |
| i | 128851 | |
| N | 124 | < 0.1% |
| - | 124 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 902825 | |
| Uppercase Letter | 129099 | 11.1% |
| Other Punctuation | 128851 | 11.1% |
| Dash Punctuation | 124 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 257950 | |
| o | 129099 | |
| m | 128975 | |
| a | 128975 | |
| z | 128975 | |
| i | 128851 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 128975 | |
| N | 124 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 128851 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 124 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1031924 | |
| Common | 128975 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 257950 | |
| o | 129099 | |
| A | 128975 | |
| m | 128975 | |
| a | 128975 | |
| z | 128975 | |
| i | 128851 | |
| N | 124 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| . | 128851 | |
| - | 124 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1160899 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 257950 | |
| o | 129099 | |
| A | 128975 | |
| m | 128975 | |
| a | 128975 | |
| z | 128975 | |
| . | 128851 | |
| i | 128851 | |
| N | 124 | < 0.1% |
| - | 124 | < 0.1% |
ship-service-level
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
| Expedited | |
|---|---|
| Standard |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.6870711 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1120415 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Standard |
|---|---|
| 2nd row | Standard |
| 3rd row | Expedited |
| 4th row | Standard |
| 5th row | Expedited |
Common Values
| Value | Count | Frequency (%) |
| Expedited | 88615 | |
| Standard | 40360 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| expedited | 88615 | |
| standard | 40360 |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 257950 | |
| e | 177230 | |
| t | 128975 | |
| E | 88615 | 7.9% |
| x | 88615 | 7.9% |
| p | 88615 | 7.9% |
| i | 88615 | 7.9% |
| a | 80720 | 7.2% |
| S | 40360 | 3.6% |
| n | 40360 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 991440 | |
| Uppercase Letter | 128975 | 11.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 257950 | |
| e | 177230 | |
| t | 128975 | |
| x | 88615 | 8.9% |
| p | 88615 | 8.9% |
| i | 88615 | 8.9% |
| a | 80720 | 8.1% |
| n | 40360 | 4.1% |
| r | 40360 | 4.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 88615 | |
| S | 40360 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1120415 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| d | 257950 | |
| e | 177230 | |
| t | 128975 | |
| E | 88615 | 7.9% |
| x | 88615 | 7.9% |
| p | 88615 | 7.9% |
| i | 88615 | 7.9% |
| a | 80720 | 7.2% |
| S | 40360 | 3.6% |
| n | 40360 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1120415 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| d | 257950 | |
| e | 177230 | |
| t | 128975 | |
| E | 88615 | 7.9% |
| x | 88615 | 7.9% |
| p | 88615 | 7.9% |
| i | 88615 | 7.9% |
| a | 80720 | 7.2% |
| S | 40360 | 3.6% |
| n | 40360 | 3.6% |
Style
Text
| Distinct | 1377 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.2124675 |
| Min length | 5 |
Characters and Unicode
| Total characters | 801253 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 117 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | SET389 |
|---|---|
| 2nd row | JNE3781 |
| 3rd row | JNE3371 |
| 4th row | J0341 |
| 5th row | JNE3671 |
| Value | Count | Frequency (%) |
| jne3797 | 4224 | 3.3% |
| jne3405 | 2263 | 1.8% |
| j0230 | 1868 | 1.4% |
| set268 | 1860 | 1.4% |
| j0341 | 1630 | 1.3% |
| j0003 | 1627 | 1.3% |
| set324 | 1284 | 1.0% |
| set345 | 1250 | 1.0% |
| jne3373 | 1173 | 0.9% |
| jne3440 | 1054 | 0.8% |
| Other values (1367) | 110742 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 112713 | |
| E | 94474 | |
| J | 86819 | |
| 0 | 82160 | |
| N | 62119 | 7.8% |
| 1 | 40872 | 5.1% |
| 2 | 40109 | 5.0% |
| 4 | 39852 | 5.0% |
| 7 | 38572 | 4.8% |
| T | 35079 | 4.4% |
| Other values (15) | 168484 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 477803 | |
| Uppercase Letter | 323450 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 94474 | |
| J | 86819 | |
| N | 62119 | |
| T | 35079 | 10.8% |
| S | 34901 | 10.8% |
| M | 4360 | 1.3% |
| W | 2317 | 0.7% |
| P | 1718 | 0.5% |
| B | 767 | 0.2% |
| L | 451 | 0.1% |
| Other values (5) | 445 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 112713 | |
| 0 | 82160 | |
| 1 | 40872 | 8.6% |
| 2 | 40109 | 8.4% |
| 4 | 39852 | 8.3% |
| 7 | 38572 | 8.1% |
| 8 | 32460 | 6.8% |
| 9 | 31415 | 6.6% |
| 5 | 30087 | 6.3% |
| 6 | 29563 | 6.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 477803 | |
| Latin | 323450 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 94474 | |
| J | 86819 | |
| N | 62119 | |
| T | 35079 | 10.8% |
| S | 34901 | 10.8% |
| M | 4360 | 1.3% |
| W | 2317 | 0.7% |
| P | 1718 | 0.5% |
| B | 767 | 0.2% |
| L | 451 | 0.1% |
| Other values (5) | 445 | 0.1% |
Common
| Value | Count | Frequency (%) |
| 3 | 112713 | |
| 0 | 82160 | |
| 1 | 40872 | 8.6% |
| 2 | 40109 | 8.4% |
| 4 | 39852 | 8.3% |
| 7 | 38572 | 8.1% |
| 8 | 32460 | 6.8% |
| 9 | 31415 | 6.6% |
| 5 | 30087 | 6.3% |
| 6 | 29563 | 6.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 801253 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 112713 | |
| E | 94474 | |
| J | 86819 | |
| 0 | 82160 | |
| N | 62119 | 7.8% |
| 1 | 40872 | 5.1% |
| 2 | 40109 | 5.0% |
| 4 | 39852 | 5.0% |
| 7 | 38572 | 4.8% |
| T | 35079 | 4.4% |
| Other values (15) | 168484 |
SKU
Text
| Distinct | 7195 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
Length
| Max length | 29 |
|---|---|
| Median length | 27 |
| Mean length | 13.363807 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1723597 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 893 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | SET389-KR-NP-S |
|---|---|
| 2nd row | JNE3781-KR-XXXL |
| 3rd row | JNE3371-KR-XL |
| 4th row | J0341-DR-L |
| 5th row | JNE3671-TU-XXXL |
| Value | Count | Frequency (%) |
| jne3797-kr-l | 773 | 0.6% |
| jne3797-kr-m | 657 | 0.5% |
| jne3797-kr-s | 587 | 0.5% |
| jne3405-kr-l | 535 | 0.4% |
| j0230-skd-m | 507 | 0.4% |
| jne3797-kr-xl | 474 | 0.4% |
| j0230-skd-s | 452 | 0.4% |
| jne3405-kr-s | 443 | 0.3% |
| jne3797-kr-xs | 431 | 0.3% |
| jne3797-kr-xxl | 395 | 0.3% |
| Other values (7186) | 123887 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 305956 | |
| 3 | 114980 | 6.7% |
| X | 114392 | 6.6% |
| R | 101927 | 5.9% |
| E | 99609 | 5.8% |
| K | 99485 | 5.8% |
| N | 90548 | 5.3% |
| J | 88172 | 5.1% |
| 0 | 83775 | 4.9% |
| L | 79565 | 4.6% |
| Other values (26) | 545188 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 924270 | |
| Decimal Number | 493039 | |
| Dash Punctuation | 305956 | 17.8% |
| Space Separator | 332 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 114392 | |
| R | 101927 | |
| E | 99609 | |
| K | 99485 | |
| N | 90548 | |
| J | 88172 | |
| L | 79565 | |
| S | 78899 | |
| T | 54737 | |
| P | 53213 | |
| Other values (14) | 63723 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 114980 | |
| 0 | 83775 | |
| 1 | 43978 | 8.9% |
| 4 | 41363 | 8.4% |
| 2 | 40957 | 8.3% |
| 7 | 39908 | 8.1% |
| 8 | 33423 | 6.8% |
| 5 | 32287 | 6.5% |
| 9 | 31775 | 6.4% |
| 6 | 30593 | 6.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 305956 |
Space Separator
| Value | Count | Frequency (%) |
| 332 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 924270 | |
| Common | 799327 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| X | 114392 | |
| R | 101927 | |
| E | 99609 | |
| K | 99485 | |
| N | 90548 | |
| J | 88172 | |
| L | 79565 | |
| S | 78899 | |
| T | 54737 | |
| P | 53213 | |
| Other values (14) | 63723 |
Common
| Value | Count | Frequency (%) |
| - | 305956 | |
| 3 | 114980 | 14.4% |
| 0 | 83775 | 10.5% |
| 1 | 43978 | 5.5% |
| 4 | 41363 | 5.2% |
| 2 | 40957 | 5.1% |
| 7 | 39908 | 5.0% |
| 8 | 33423 | 4.2% |
| 5 | 32287 | 4.0% |
| 9 | 31775 | 4.0% |
| Other values (2) | 30925 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1723597 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 305956 | |
| 3 | 114980 | 6.7% |
| X | 114392 | 6.6% |
| R | 101927 | 5.9% |
| E | 99609 | 5.8% |
| K | 99485 | 5.8% |
| N | 90548 | 5.3% |
| J | 88172 | 5.1% |
| 0 | 83775 | 4.9% |
| L | 79565 | 4.6% |
| Other values (26) | 545188 |
Category
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
| Set | |
|---|---|
| kurta | |
| Western Dress | |
| Top | |
| Ethnic Dress | 1159 |
| Other values (4) | 1533 |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 5.0905059 |
| Min length | 3 |
Characters and Unicode
| Total characters | 656548 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Set |
|---|---|
| 2nd row | kurta |
| 3rd row | kurta |
| 4th row | Western Dress |
| 5th row | Top |
Common Values
| Value | Count | Frequency (%) |
| Set | 50284 | |
| kurta | 49877 | |
| Western Dress | 15500 | 12.0% |
| Top | 10622 | 8.2% |
| Ethnic Dress | 1159 | 0.9% |
| Blouse | 926 | 0.7% |
| Bottom | 440 | 0.3% |
| Saree | 164 | 0.1% |
| Dupatta | 3 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| set | 50284 | |
| kurta | 49877 | |
| dress | 16659 | 11.4% |
| western | 15500 | 10.6% |
| top | 10622 | 7.3% |
| ethnic | 1159 | 0.8% |
| blouse | 926 | 0.6% |
| bottom | 440 | 0.3% |
| saree | 164 | 0.1% |
| dupatta | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 117706 | |
| e | 99197 | |
| r | 82200 | |
| u | 50806 | |
| S | 50448 | |
| a | 50047 | |
| k | 49877 | |
| s | 49744 | |
| D | 16662 | 2.5% |
| n | 16659 | 2.5% |
| Other values (12) | 73202 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 544132 | |
| Uppercase Letter | 95757 | 14.6% |
| Space Separator | 16659 | 2.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 117706 | |
| e | 99197 | |
| r | 82200 | |
| u | 50806 | |
| a | 50047 | |
| k | 49877 | |
| s | 49744 | |
| n | 16659 | 3.1% |
| o | 12428 | 2.3% |
| p | 10625 | 2.0% |
| Other values (5) | 4843 | 0.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 50448 | |
| D | 16662 | 17.4% |
| W | 15500 | 16.2% |
| T | 10622 | 11.1% |
| B | 1366 | 1.4% |
| E | 1159 | 1.2% |
Space Separator
| Value | Count | Frequency (%) |
| 16659 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 639889 | |
| Common | 16659 | 2.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 117706 | |
| e | 99197 | |
| r | 82200 | |
| u | 50806 | |
| S | 50448 | |
| a | 50047 | |
| k | 49877 | |
| s | 49744 | |
| D | 16662 | 2.6% |
| n | 16659 | 2.6% |
| Other values (11) | 56543 |
Common
| Value | Count | Frequency (%) |
| 16659 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 656548 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 117706 | |
| e | 99197 | |
| r | 82200 | |
| u | 50806 | |
| S | 50448 | |
| a | 50047 | |
| k | 49877 | |
| s | 49744 | |
| D | 16662 | 2.5% |
| n | 16659 | 2.5% |
| Other values (12) | 73202 |
Size
Categorical
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
| M | |
|---|---|
| L | |
| XL | |
| XXL | |
| S | |
| Other values (6) |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 1.7941462 |
| Min length | 1 |
Characters and Unicode
| Total characters | 231400 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | S |
|---|---|
| 2nd row | 3XL |
| 3rd row | XL |
| 4th row | L |
| 5th row | 3XL |
Common Values
| Value | Count | Frequency (%) |
| M | 22711 | |
| L | 22132 | |
| XL | 20876 | |
| XXL | 18096 | |
| S | 17090 | |
| 3XL | 14816 | |
| XS | 11161 | |
| 6XL | 738 | 0.6% |
| 5XL | 550 | 0.4% |
| 4XL | 427 | 0.3% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| m | 22711 | |
| l | 22132 | |
| xl | 20876 | |
| xxl | 18096 | |
| s | 17090 | |
| 3xl | 14816 | |
| xs | 11161 | |
| 6xl | 738 | 0.6% |
| 5xl | 550 | 0.4% |
| 4xl | 427 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| X | 84760 | |
| L | 77635 | |
| S | 28251 | 12.2% |
| M | 22711 | 9.8% |
| 3 | 14816 | 6.4% |
| e | 756 | 0.3% |
| 6 | 738 | 0.3% |
| 5 | 550 | 0.2% |
| 4 | 427 | 0.2% |
| F | 378 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 213735 | |
| Decimal Number | 16531 | 7.1% |
| Lowercase Letter | 1134 | 0.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 84760 | |
| L | 77635 | |
| S | 28251 | 13.2% |
| M | 22711 | 10.6% |
| F | 378 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 14816 | |
| 6 | 738 | 4.5% |
| 5 | 550 | 3.3% |
| 4 | 427 | 2.6% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 756 | |
| r | 378 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 214869 | |
| Common | 16531 | 7.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| X | 84760 | |
| L | 77635 | |
| S | 28251 | 13.1% |
| M | 22711 | 10.6% |
| e | 756 | 0.4% |
| F | 378 | 0.2% |
| r | 378 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 3 | 14816 | |
| 6 | 738 | 4.5% |
| 5 | 550 | 3.3% |
| 4 | 427 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 231400 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| X | 84760 | |
| L | 77635 | |
| S | 28251 | 12.2% |
| M | 22711 | 9.8% |
| 3 | 14816 | 6.4% |
| e | 756 | 0.3% |
| 6 | 738 | 0.3% |
| 5 | 550 | 0.2% |
| 4 | 427 | 0.2% |
| F | 378 | 0.2% |
ASIN
Text
| Distinct | 7190 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1007.7 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1289750 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 890 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | B09KXVBD7Z |
|---|---|
| 2nd row | B09K3WFS32 |
| 3rd row | B07WV4JV4D |
| 4th row | B099NRCT7B |
| 5th row | B098714BZP |
| Value | Count | Frequency (%) |
| b09sdxffq1 | 773 | 0.6% |
| b09sdy8dct | 657 | 0.5% |
| b09sdyq3wg | 587 | 0.5% |
| b081wsckpq | 535 | 0.4% |
| b08xnjg8b1 | 507 | 0.4% |
| b09sdxrybg | 474 | 0.4% |
| b08xnj19qh | 452 | 0.4% |
| b081wx4g4q | 443 | 0.3% |
| b09sdy9sq6 | 431 | 0.3% |
| b09sdxsq33 | 395 | 0.3% |
| Other values (7180) | 123721 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 157501 | 12.2% |
| 0 | 129068 | 10.0% |
| 9 | 108169 | 8.4% |
| 8 | 81753 | 6.3% |
| 3 | 39248 | 3.0% |
| Y | 37669 | 2.9% |
| X | 37593 | 2.9% |
| K | 37458 | 2.9% |
| Q | 35997 | 2.8% |
| 1 | 35838 | 2.8% |
| Other values (26) | 589456 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 749455 | |
| Decimal Number | 540295 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 157501 | |
| Y | 37669 | 5.0% |
| X | 37593 | 5.0% |
| K | 37458 | 5.0% |
| Q | 35997 | 4.8% |
| R | 34053 | 4.5% |
| N | 33810 | 4.5% |
| S | 33167 | 4.4% |
| D | 32427 | 4.3% |
| W | 30477 | 4.1% |
| Other values (16) | 279303 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 129068 | |
| 9 | 108169 | |
| 8 | 81753 | |
| 3 | 39248 | 7.3% |
| 1 | 35838 | 6.6% |
| 2 | 34579 | 6.4% |
| 4 | 33514 | 6.2% |
| 7 | 31465 | 5.8% |
| 6 | 24075 | 4.5% |
| 5 | 22586 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 749455 | |
| Common | 540295 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 157501 | |
| Y | 37669 | 5.0% |
| X | 37593 | 5.0% |
| K | 37458 | 5.0% |
| Q | 35997 | 4.8% |
| R | 34053 | 4.5% |
| N | 33810 | 4.5% |
| S | 33167 | 4.4% |
| D | 32427 | 4.3% |
| W | 30477 | 4.1% |
| Other values (16) | 279303 |
Common
| Value | Count | Frequency (%) |
| 0 | 129068 | |
| 9 | 108169 | |
| 8 | 81753 | |
| 3 | 39248 | 7.3% |
| 1 | 35838 | 6.6% |
| 2 | 34579 | 6.4% |
| 4 | 33514 | 6.2% |
| 7 | 31465 | 5.8% |
| 6 | 24075 | 4.5% |
| 5 | 22586 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1289750 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 157501 | 12.2% |
| 0 | 129068 | 10.0% |
| 9 | 108169 | 8.4% |
| 8 | 81753 | 6.3% |
| 3 | 39248 | 3.0% |
| Y | 37669 | 2.9% |
| X | 37593 | 2.9% |
| K | 37458 | 2.9% |
| Q | 35997 | 2.8% |
| 1 | 35838 | 2.8% |
| Other values (26) | 589456 |
Courier Status
Categorical
IMBALANCE MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6872 |
| Missing (%) | 5.3% |
| Memory size | 1007.7 KiB |
| Shipped | |
|---|---|
| Unshipped | 6681 |
| Cancelled | 5935 |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.2066452 |
| Min length | 7 |
Characters and Unicode
| Total characters | 879953 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Shipped |
|---|---|
| 2nd row | Shipped |
| 3rd row | Shipped |
| 4th row | Shipped |
| 5th row | Shipped |
Common Values
| Value | Count | Frequency (%) |
| Shipped | 109487 | |
| Unshipped | 6681 | 5.2% |
| Cancelled | 5935 | 4.6% |
| (Missing) | 6872 | 5.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| shipped | 109487 | |
| unshipped | 6681 | 5.5% |
| cancelled | 5935 | 4.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 232336 | |
| e | 128038 | |
| d | 122103 | |
| h | 116168 | |
| i | 116168 | |
| S | 109487 | |
| n | 12616 | 1.4% |
| l | 11870 | 1.3% |
| U | 6681 | 0.8% |
| s | 6681 | 0.8% |
| Other values (3) | 17805 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 757850 | |
| Uppercase Letter | 122103 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 232336 | |
| e | 128038 | |
| d | 122103 | |
| h | 116168 | |
| i | 116168 | |
| n | 12616 | 1.7% |
| l | 11870 | 1.6% |
| s | 6681 | 0.9% |
| a | 5935 | 0.8% |
| c | 5935 | 0.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 109487 | |
| U | 6681 | 5.5% |
| C | 5935 | 4.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 879953 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| p | 232336 | |
| e | 128038 | |
| d | 122103 | |
| h | 116168 | |
| i | 116168 | |
| S | 109487 | |
| n | 12616 | 1.4% |
| l | 11870 | 1.3% |
| U | 6681 | 0.8% |
| s | 6681 | 0.8% |
| Other values (3) | 17805 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 879953 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| p | 232336 | |
| e | 128038 | |
| d | 122103 | |
| h | 116168 | |
| i | 116168 | |
| S | 109487 | |
| n | 12616 | 1.4% |
| l | 11870 | 1.3% |
| U | 6681 | 0.8% |
| s | 6681 | 0.8% |
| Other values (3) | 17805 | 2.0% |
Qty
Real number (ℝ)
ZEROS
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.90443109 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 12807 |
| Zeros (%) | 9.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1007.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.31335359 |
|---|---|
| Coefficient of variation (CV) | 0.34646485 |
| Kurtosis | 60.36258 |
| Mean | 0.90443109 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.69767777 |
| Sum | 116649 |
| Variance | 0.09819047 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 1 | 115780 | |
| 0 | 12807 | 9.9% |
| 2 | 341 | 0.3% |
| 3 | 32 | < 0.1% |
| 4 | 9 | < 0.1% |
| 5 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 12807 | 9.9% |
| 1 | 115780 | |
| 2 | 341 | 0.3% |
| 3 | 32 | < 0.1% |
| 4 | 9 | < 0.1% |
| 5 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 4 | 9 | < 0.1% |
| 3 | 32 | < 0.1% |
| 2 | 341 | 0.3% |
| 1 | 115780 | |
| 0 | 12807 | 9.9% |
currency
Categorical
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7795 |
| Missing (%) | 6.0% |
| Memory size | 1007.7 KiB |
| INR |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 363540 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | INR |
|---|---|
| 2nd row | INR |
| 3rd row | INR |
| 4th row | INR |
| 5th row | INR |
Common Values
| Value | Count | Frequency (%) |
| INR | 121180 | |
| (Missing) | 7795 | 6.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| inr | 121180 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 121180 | |
| N | 121180 | |
| R | 121180 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 363540 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 121180 | |
| N | 121180 | |
| R | 121180 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 363540 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 121180 | |
| N | 121180 | |
| R | 121180 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 363540 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 121180 | |
| N | 121180 | |
| R | 121180 |
Amount
Real number (ℝ)
MISSING ZEROS
| Distinct | 1410 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 7795 |
| Missing (%) | 6.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 648.56146 |
| Minimum | 0 |
|---|---|
| Maximum | 5584 |
| Zeros | 2343 |
| Zeros (%) | 1.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1007.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 301 |
| Q1 | 449 |
| median | 605 |
| Q3 | 788 |
| 95-th percentile | 1176 |
| Maximum | 5584 |
| Range | 5584 |
| Interquartile range (IQR) | 339 |
Descriptive statistics
| Standard deviation | 281.21169 |
|---|---|
| Coefficient of variation (CV) | 0.43359296 |
| Kurtosis | 3.0037534 |
| Mean | 648.56146 |
| Median Absolute Deviation (MAD) | 168.81 |
| Skewness | 0.88548064 |
| Sum | 78592678 |
| Variance | 79080.013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 399 | 5442 | 4.2% |
| 771 | 2797 | 2.2% |
| 735 | 2436 | 1.9% |
| 0 | 2343 | 1.8% |
| 487 | 2293 | 1.8% |
| 788 | 1969 | 1.5% |
| 301 | 1865 | 1.4% |
| 376 | 1810 | 1.4% |
| 635 | 1787 | 1.4% |
| 999 | 1615 | 1.3% |
| Other values (1400) | 96823 | |
| (Missing) | 7795 | 6.0% |
| Value | Count | Frequency (%) |
| 0 | 2343 | |
| 199 | 3 | < 0.1% |
| 218.1 | 1 | < 0.1% |
| 229 | 21 | < 0.1% |
| 236.19 | 2 | < 0.1% |
| 237.14 | 4 | < 0.1% |
| 241 | 4 | < 0.1% |
| 246.67 | 7 | < 0.1% |
| 248 | 4 | < 0.1% |
| 249 | 54 | < 0.1% |
| Value | Count | Frequency (%) |
| 5584 | 1 | |
| 5495 | 1 | |
| 4235.72 | 1 | |
| 3036 | 1 | |
| 2894 | 1 | |
| 2864 | 1 | |
| 2860 | 1 | |
| 2796 | 1 | |
| 2698 | 1 | |
| 2676 | 1 |
ship-city
Text
| Distinct | 8955 |
|---|---|
| Distinct (%) | 6.9% |
| Missing | 33 |
| Missing (%) | < 0.1% |
| Memory size | 1007.7 KiB |
Length
| Max length | 50 |
|---|---|
| Median length | 48 |
| Mean length | 8.4392905 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1088179 |
|---|---|
| Distinct characters | 82 |
| Distinct categories | 9 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4250 ? |
|---|---|
| Unique (%) | 3.3% |
Sample
| 1st row | MUMBAI |
|---|---|
| 2nd row | BENGALURU |
| 3rd row | NAVI MUMBAI |
| 4th row | PUDUCHERRY |
| 5th row | CHENNAI |
| Value | Count | Frequency (%) |
| bengaluru | 11944 | 8.1% |
| hyderabad | 9203 | 6.2% |
| mumbai | 8746 | 5.9% |
| delhi | 6899 | 4.7% |
| new | 6706 | 4.5% |
| chennai | 6352 | 4.3% |
| pune | 4723 | 3.2% |
| kolkata | 2911 | 2.0% |
| noida | 2291 | 1.5% |
| thane | 2054 | 1.4% |
| Other values (6828) | 86383 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 158769 | 14.6% |
| R | 70219 | 6.5% |
| N | 69345 | 6.4% |
| U | 68516 | 6.3% |
| E | 60419 | 5.6% |
| I | 56759 | 5.2% |
| H | 50839 | 4.7% |
| D | 50273 | 4.6% |
| B | 44231 | 4.1% |
| L | 41160 | 3.8% |
| Other values (72) | 417649 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 908899 | |
| Lowercase Letter | 155080 | 14.3% |
| Space Separator | 19387 | 1.8% |
| Decimal Number | 2170 | 0.2% |
| Other Punctuation | 1859 | 0.2% |
| Dash Punctuation | 280 | < 0.1% |
| Open Punctuation | 251 | < 0.1% |
| Close Punctuation | 245 | < 0.1% |
| Other Letter | 8 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 31617 | |
| r | 13045 | 8.4% |
| i | 11289 | 7.3% |
| n | 11213 | 7.2% |
| e | 10740 | 6.9% |
| u | 9881 | 6.4% |
| l | 8081 | 5.2% |
| d | 7984 | 5.1% |
| h | 7818 | 5.0% |
| o | 6372 | 4.1% |
| Other values (17) | 37040 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 158769 | |
| R | 70219 | 7.7% |
| N | 69345 | 7.6% |
| U | 68516 | 7.5% |
| E | 60419 | 6.6% |
| I | 56759 | 6.2% |
| H | 50839 | 5.6% |
| D | 50273 | 5.5% |
| B | 44231 | 4.9% |
| L | 41160 | 4.5% |
| Other values (16) | 238369 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 698 | |
| 1 | 277 | 12.8% |
| 4 | 262 | 12.1% |
| 2 | 208 | 9.6% |
| 6 | 182 | 8.4% |
| 5 | 141 | 6.5% |
| 7 | 116 | 5.3% |
| 3 | 113 | 5.2% |
| 8 | 109 | 5.0% |
| 9 | 64 | 2.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 1459 | |
| . | 323 | 17.4% |
| / | 34 | 1.8% |
| : | 31 | 1.7% |
| ; | 7 | 0.4% |
| ' | 3 | 0.2% |
| & | 2 | 0.1% |
Other Letter
| Value | Count | Frequency (%) |
| ल | 2 | |
| ख | 2 | |
| न | 2 | |
| ऊ | 2 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 248 | |
| [ | 2 | 0.8% |
| { | 1 | 0.4% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 242 | |
| ] | 2 | 0.8% |
| } | 1 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 19387 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1063979 | |
| Common | 24192 | 2.2% |
| Devanagari | 8 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 158769 | |
| R | 70219 | 6.6% |
| N | 69345 | 6.5% |
| U | 68516 | 6.4% |
| E | 60419 | 5.7% |
| I | 56759 | 5.3% |
| H | 50839 | 4.8% |
| D | 50273 | 4.7% |
| B | 44231 | 4.2% |
| L | 41160 | 3.9% |
| Other values (43) | 393449 |
Common
| Value | Count | Frequency (%) |
| 19387 | ||
| , | 1459 | 6.0% |
| 0 | 698 | 2.9% |
| . | 323 | 1.3% |
| - | 280 | 1.2% |
| 1 | 277 | 1.1% |
| 4 | 262 | 1.1% |
| ( | 248 | 1.0% |
| ) | 242 | 1.0% |
| 2 | 208 | 0.9% |
| Other values (15) | 808 | 3.3% |
Devanagari
| Value | Count | Frequency (%) |
| ल | 2 | |
| ख | 2 | |
| न | 2 | |
| ऊ | 2 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1088170 | |
| Devanagari | 8 | < 0.1% |
| None | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 158769 | 14.6% |
| R | 70219 | 6.5% |
| N | 69345 | 6.4% |
| U | 68516 | 6.3% |
| E | 60419 | 5.6% |
| I | 56759 | 5.2% |
| H | 50839 | 4.7% |
| D | 50273 | 4.6% |
| B | 44231 | 4.1% |
| L | 41160 | 3.8% |
| Other values (67) | 417640 |
Devanagari
| Value | Count | Frequency (%) |
| ल | 2 | |
| ख | 2 | |
| न | 2 | |
| ऊ | 2 |
None
| Value | Count | Frequency (%) |
| Ã | 1 |
ship-state
Text
| Distinct | 69 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 33 |
| Missing (%) | < 0.1% |
| Memory size | 1007.7 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 17 |
| Mean length | 9.533961 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1229328 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | MAHARASHTRA |
|---|---|
| 2nd row | KARNATAKA |
| 3rd row | MAHARASHTRA |
| 4th row | PUDUCHERRY |
| 5th row | TAMIL NADU |
| Value | Count | Frequency (%) |
| maharashtra | 22260 | |
| pradesh | 19531 | |
| karnataka | 17326 | 10.3% |
| nadu | 11483 | 6.8% |
| tamil | 11483 | 6.8% |
| telangana | 11330 | 6.7% |
| uttar | 10638 | 6.3% |
| delhi | 7048 | 4.2% |
| kerala | 6585 | 3.9% |
| west | 5963 | 3.5% |
| Other values (45) | 44411 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 328824 | |
| R | 120104 | 9.8% |
| H | 100908 | 8.2% |
| T | 97363 | 7.9% |
| N | 76942 | 6.3% |
| S | 57660 | 4.7% |
| E | 56710 | 4.6% |
| D | 52488 | 4.3% |
| K | 45399 | 3.7% |
| L | 43509 | 3.5% |
| Other values (37) | 249421 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1159428 | |
| Space Separator | 39373 | 3.2% |
| Lowercase Letter | 29566 | 2.4% |
| Other Punctuation | 961 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 328824 | |
| R | 120104 | 10.4% |
| H | 100908 | 8.7% |
| T | 97363 | 8.4% |
| N | 76942 | 6.6% |
| S | 57660 | 5.0% |
| E | 56710 | 4.9% |
| D | 52488 | 4.5% |
| K | 45399 | 3.9% |
| L | 43509 | 3.8% |
| Other values (12) | 179521 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 9364 | |
| j | 4604 | |
| r | 4560 | |
| t | 4555 | |
| u | 4551 | |
| h | 422 | 1.4% |
| e | 357 | 1.2% |
| i | 344 | 1.2% |
| l | 276 | 0.9% |
| n | 138 | 0.5% |
| Other values (12) | 395 | 1.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 959 | |
| / | 2 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 39373 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1188994 | |
| Common | 40334 | 3.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 328824 | |
| R | 120104 | 10.1% |
| H | 100908 | 8.5% |
| T | 97363 | 8.2% |
| N | 76942 | 6.5% |
| S | 57660 | 4.8% |
| E | 56710 | 4.8% |
| D | 52488 | 4.4% |
| K | 45399 | 3.8% |
| L | 43509 | 3.7% |
| Other values (34) | 209087 |
Common
| Value | Count | Frequency (%) |
| 39373 | ||
| & | 959 | 2.4% |
| / | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1229328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 328824 | |
| R | 120104 | 9.8% |
| H | 100908 | 8.2% |
| T | 97363 | 7.9% |
| N | 76942 | 6.3% |
| S | 57660 | 4.7% |
| E | 56710 | 4.6% |
| D | 52488 | 4.3% |
| K | 45399 | 3.7% |
| L | 43509 | 3.5% |
| Other values (37) | 249421 |
ship-postal-code
Real number (ℝ)
| Distinct | 9459 |
|---|---|
| Distinct (%) | 7.3% |
| Missing | 33 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 463966.24 |
| Minimum | 110001 |
|---|---|
| Maximum | 989898 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1007.7 KiB |
Quantile statistics
| Minimum | 110001 |
|---|---|
| 5-th percentile | 110092 |
| Q1 | 382421 |
| median | 500033 |
| Q3 | 600024 |
| 95-th percentile | 769004 |
| Maximum | 989898 |
| Range | 879897 |
| Interquartile range (IQR) | 217603 |
Descriptive statistics
| Standard deviation | 191476.76 |
|---|---|
| Coefficient of variation (CV) | 0.41269547 |
| Kurtosis | -0.68487475 |
| Mean | 463966.24 |
| Median Absolute Deviation (MAD) | 100040 |
| Skewness | -0.25833077 |
| Sum | 5.9824734 × 1010 |
| Variance | 3.6663352 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 201301 | 1006 | 0.8% |
| 122001 | 688 | 0.5% |
| 560037 | 632 | 0.5% |
| 560068 | 619 | 0.5% |
| 560076 | 581 | 0.5% |
| 560043 | 500 | 0.4% |
| 401107 | 493 | 0.4% |
| 500072 | 490 | 0.4% |
| 560100 | 489 | 0.4% |
| 560066 | 464 | 0.4% |
| Other values (9449) | 122980 |
| Value | Count | Frequency (%) |
| 110001 | 49 | |
| 110002 | 41 | < 0.1% |
| 110003 | 65 | |
| 110004 | 1 | < 0.1% |
| 110005 | 70 | |
| 110006 | 41 | < 0.1% |
| 110007 | 52 | |
| 110008 | 86 | |
| 110009 | 106 | |
| 110010 | 54 |
| Value | Count | Frequency (%) |
| 989898 | 1 | < 0.1% |
| 984196 | 1 | < 0.1% |
| 959121 | 1 | < 0.1% |
| 855117 | 2 | < 0.1% |
| 855116 | 2 | < 0.1% |
| 855115 | 2 | < 0.1% |
| 855113 | 9 | |
| 855108 | 2 | < 0.1% |
| 855107 | 7 | |
| 855102 | 9 |
ship-country
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 33 |
| Missing (%) | < 0.1% |
| Memory size | 1007.7 KiB |
| IN |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 257884 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IN |
|---|---|
| 2nd row | IN |
| 3rd row | IN |
| 4th row | IN |
| 5th row | IN |
Common Values
| Value | Count | Frequency (%) |
| IN | 128942 | |
| (Missing) | 33 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| in | 128942 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 128942 | |
| N | 128942 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 257884 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 128942 | |
| N | 128942 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 257884 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 128942 | |
| N | 128942 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 257884 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 128942 | |
| N | 128942 |
promotion-ids
Text
MISSING
| Distinct | 5787 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 49153 |
| Missing (%) | 38.1% |
| Memory size | 1007.7 KiB |
Length
| Max length | 2317 |
|---|---|
| Median length | 44 |
| Mean length | 565.96919 |
| Min length | 25 |
Characters and Unicode
| Total characters | 45176793 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2719 ? |
|---|---|
| Unique (%) | 3.4% |
Sample
| 1st row | Amazon PLCC Free-Financing Universal Merchant AAT-WNKTBO3K27EJC,Amazon PLCC Free-Financing Universal Merchant AAT-QX3UCCJESKPA2,Amazon PLCC Free-Financing Universal Merchant AAT-5QQ7BIYYQEDN2,Amazon PLCC Free-Financing Universal Merchant AAT-DSJ2QRXXWXVMQ,Amazon PLCC Free-Financing Universal Merchant AAT-CXJHMC2YJUK76,Amazon PLCC Free-Financing Universal Merchant AAT-CC4FAVTYR4X7C,Amazon PLCC Free-Financing Universal Merchant AAT-XXRCW6NZEPZI4,Amazon PLCC Free-Financing Universal Merchant AAT-CXNSLNBROFDW4,Amazon PLCC Free-Financing Universal Merchant AAT-R7GXNZWISTRFA,Amazon PLCC Free-Financing Universal Merchant AAT-WSJLDN3X7KEMO,Amazon PLCC Free-Financing Universal Merchant AAT-VL6FGQVGQVXUS,Amazon PLCC Free-Financing Universal Merchant AAT-EOKPWFWYW7Y6I,Amazon PLCC Free-Financing Universal Merchant AAT-ZYL5UPUNW6T62,Amazon PLCC Free-Financing Universal Merchant AAT-XVPICCHRWDCAI,Amazon PLCC Free-Financing Universal Merchant AAT-ETXQ3XXWMRXBG,Amazon PLCC Free-Financing Universal Merchant AAT-7X3XCTYG64VBE,Amazon PLCC Free-Financing Universal Merchant AAT-7CHGD3WTS3MHM,Amazon PLCC Free-Financing Universal Merchant AAT-26ZDKNME27X42,Amazon PLCC Free-Financing Universal Merchant AAT-4ZF5KN6E4LJK4,Amazon PLCC Free-Financing Universal Merchant AAT-7RCXIKUAX7DDY,Amazon PLCC Free-Financing Universal Merchant AAT-BRSZZ45H6MHAO,Amazon PLCC Free-Financing Universal Merchant AAT-MKLXOOZWQL7GO,Amazon PLCC Free-Financing Universal Merchant AAT-CB7UNXEXGIJTC,Amazon PLCC Free-Financing Universal Merchant #MP-gzasho-1593152694811,Amazon PLCC Free-Financing Universal Merchant AAT-WLBA4GZ52EAH4 |
|---|---|
| 2nd row | IN Core Free Shipping 2015/04/08 23-48-5-108 |
| 3rd row | IN Core Free Shipping 2015/04/08 23-48-5-108 |
| 4th row | IN Core Free Shipping 2015/04/08 23-48-5-108 |
| 5th row | Amazon PLCC Free-Financing Universal Merchant AAT-WNKTBO3K27EJC,Amazon PLCC Free-Financing Universal Merchant AAT-QX3UCCJESKPA2,Amazon PLCC Free-Financing Universal Merchant AAT-5QQ7BIYYQEDN2,Amazon PLCC Free-Financing Universal Merchant AAT-DSJ2QRXXWXVMQ,Amazon PLCC Free-Financing Universal Merchant AAT-CXJHMC2YJUK76,Amazon PLCC Free-Financing Universal Merchant AAT-CC4FAVTYR4X7C,Amazon PLCC Free-Financing Universal Merchant AAT-XXRCW6NZEPZI4,Amazon PLCC Free-Financing Universal Merchant AAT-EOKPWFWYW7Y6I,Amazon PLCC Free-Financing Universal Merchant AAT-ZYL5UPUNW6T62,Amazon PLCC Free-Financing Universal Merchant AAT-ETXQ3XXWMRXBG,Amazon PLCC Free-Financing Universal Merchant AAT-7X3XCTYG64VBE,Amazon PLCC Free-Financing Universal Merchant AAT-7CHGD3WTS3MHM,Amazon PLCC Free-Financing Universal Merchant AAT-26ZDKNME27X42,Amazon PLCC Free-Financing Universal Merchant AAT-4ZF5KN6E4LJK4,Amazon PLCC Free-Financing Universal Merchant AAT-7RCXIKUAX7DDY,Amazon PLCC Free-Financing Universal Merchant AAT-BRSZZ45H6MHAO,Amazon PLCC Free-Financing Universal Merchant AAT-MKLXOOZWQL7GO,Amazon PLCC Free-Financing Universal Merchant AAT-CB7UNXEXGIJTC,Amazon PLCC Free-Financing Universal Merchant #MP-gzasho-1593152694811,Amazon PLCC Free-Financing Universal Merchant AAT-WLBA4GZ52EAH4 |
| Value | Count | Frequency (%) |
| plcc | 668899 | |
| merchant | 668899 | |
| universal | 668899 | |
| free-financing | 668899 | |
| core | 46198 | 1.3% |
| in | 46198 | 1.3% |
| 2015/04/08 | 46198 | 1.3% |
| shipping | 46198 | 1.3% |
| free | 46198 | 1.3% |
| 23-48-5-108 | 46100 | 1.3% |
| Other values (343) | 705556 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 4072086 | 9.0% |
| 3578420 | 7.9% | |
| e | 2815180 | 6.2% |
| a | 2720285 | 6.0% |
| A | 2174776 | 4.8% |
| i | 2111520 | 4.7% |
| r | 2099161 | 4.6% |
| C | 1819658 | 4.0% |
| F | 1534897 | 3.4% |
| - | 1522069 | 3.4% |
| Other values (50) | 20728741 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 21612628 | |
| Uppercase Letter | 14886832 | |
| Space Separator | 3578420 | 7.9% |
| Decimal Number | 2803529 | 6.2% |
| Dash Punctuation | 1522069 | 3.4% |
| Other Punctuation | 773315 | 1.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2174776 | |
| C | 1819658 | |
| F | 1534897 | 10.3% |
| M | 960996 | 6.5% |
| U | 922229 | 6.2% |
| P | 904375 | 6.1% |
| L | 858954 | 5.8% |
| T | 814247 | 5.5% |
| X | 420991 | 2.8% |
| W | 352381 | 2.4% |
| Other values (16) | 4123328 |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 4072086 | |
| e | 2815180 | |
| a | 2720285 | |
| i | 2111520 | |
| r | 2099161 | |
| c | 1338754 | 6.2% |
| o | 749439 | 3.5% |
| h | 747359 | 3.5% |
| g | 747359 | 3.5% |
| s | 701195 | 3.2% |
| Other values (9) | 3510290 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 437707 | |
| 4 | 398057 | |
| 5 | 369775 | |
| 7 | 318570 | |
| 6 | 284711 | |
| 3 | 254840 | |
| 1 | 251026 | |
| 0 | 210901 | |
| 8 | 186956 | |
| 9 | 90986 | 3.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 637220 | |
| / | 92396 | 11.9% |
| # | 43699 | 5.7% |
Space Separator
| Value | Count | Frequency (%) |
| 3578420 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1522069 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 36499460 | |
| Common | 8677333 | 19.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 4072086 | 11.2% |
| e | 2815180 | 7.7% |
| a | 2720285 | 7.5% |
| A | 2174776 | 6.0% |
| i | 2111520 | 5.8% |
| r | 2099161 | 5.8% |
| C | 1819658 | 5.0% |
| F | 1534897 | 4.2% |
| c | 1338754 | 3.7% |
| M | 960996 | 2.6% |
| Other values (35) | 14852147 |
Common
| Value | Count | Frequency (%) |
| 3578420 | ||
| - | 1522069 | |
| , | 637220 | 7.3% |
| 2 | 437707 | 5.0% |
| 4 | 398057 | 4.6% |
| 5 | 369775 | 4.3% |
| 7 | 318570 | 3.7% |
| 6 | 284711 | 3.3% |
| 3 | 254840 | 2.9% |
| 1 | 251026 | 2.9% |
| Other values (5) | 624938 | 7.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 45176793 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 4072086 | 9.0% |
| 3578420 | 7.9% | |
| e | 2815180 | 6.2% |
| a | 2720285 | 6.0% |
| A | 2174776 | 4.8% |
| i | 2111520 | 4.7% |
| r | 2099161 | 4.6% |
| C | 1819658 | 4.0% |
| F | 1534897 | 3.4% |
| - | 1522069 | 3.4% |
| Other values (50) | 20728741 |
B2B
Boolean
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 126.1 KiB |
| False | |
|---|---|
| True | 871 |
| Value | Count | Frequency (%) |
| False | 128104 | |
| True | 871 | 0.7% |
fulfilled-by
Categorical
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 89698 |
| Missing (%) | 69.5% |
| Memory size | 1007.7 KiB |
| Easy Ship |
|---|
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 353493 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Easy Ship |
|---|---|
| 2nd row | Easy Ship |
| 3rd row | Easy Ship |
| 4th row | Easy Ship |
| 5th row | Easy Ship |
Common Values
| Value | Count | Frequency (%) |
| Easy Ship | 39277 | |
| (Missing) | 89698 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| easy | 39277 | |
| ship | 39277 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 39277 | |
| a | 39277 | |
| s | 39277 | |
| y | 39277 | |
| 39277 | ||
| S | 39277 | |
| h | 39277 | |
| i | 39277 | |
| p | 39277 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 235662 | |
| Uppercase Letter | 78554 | 22.2% |
| Space Separator | 39277 | 11.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 39277 | |
| s | 39277 | |
| y | 39277 | |
| h | 39277 | |
| i | 39277 | |
| p | 39277 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 39277 | |
| S | 39277 |
Space Separator
| Value | Count | Frequency (%) |
| 39277 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 314216 | |
| Common | 39277 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 39277 | |
| a | 39277 | |
| s | 39277 | |
| y | 39277 | |
| S | 39277 | |
| h | 39277 | |
| i | 39277 | |
| p | 39277 |
Common
| Value | Count | Frequency (%) |
| 39277 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 353493 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 39277 | |
| a | 39277 | |
| s | 39277 | |
| y | 39277 | |
| 39277 | ||
| S | 39277 | |
| h | 39277 | |
| i | 39277 | |
| p | 39277 |
Unnamed: 22
Boolean
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 49050 |
| Missing (%) | 38.0% |
| Memory size | 1007.7 KiB |
| False | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| False | 79925 | |
| (Missing) | 49050 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| df_index | Order ID | Date | Status | Fulfilment | Sales Channel | ship-service-level | Style | SKU | Category | Size | ASIN | Courier Status | Qty | currency | Amount | ship-city | ship-state | ship-postal-code | ship-country | promotion-ids | B2B | fulfilled-by | Unnamed: 22 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 405-8078784-5731545 | 04-30-22 | Cancelled | Merchant | Amazon.in | Standard | SET389 | SET389-KR-NP-S | Set | S | B09KXVBD7Z | NaN | 0 | INR | 647.62 | MUMBAI | MAHARASHTRA | 400081.0 | IN | NaN | False | Easy Ship | NaN |
| 1 | 1 | 171-9198151-1101146 | 04-30-22 | Shipped - Delivered to Buyer | Merchant | Amazon.in | Standard | JNE3781 | JNE3781-KR-XXXL | kurta | 3XL | B09K3WFS32 | Shipped | 1 | INR | 406.00 | BENGALURU | KARNATAKA | 560085.0 | IN | Amazon PLCC Free-Financing Universal Merchant AAT-WNKTBO3K27EJC,Amazon PLCC Free-Financing Universal Merchant AAT-QX3UCCJESKPA2,Amazon PLCC Free-Financing Universal Merchant AAT-5QQ7BIYYQEDN2,Amazon PLCC Free-Financing Universal Merchant AAT-DSJ2QRXXWXVMQ,Amazon PLCC Free-Financing Universal Merchant AAT-CXJHMC2YJUK76,Amazon PLCC Free-Financing Universal Merchant AAT-CC4FAVTYR4X7C,Amazon PLCC Free-Financing Universal Merchant AAT-XXRCW6NZEPZI4,Amazon PLCC Free-Financing Universal Merchant AAT-CXNSLNBROFDW4,Amazon PLCC Free-Financing Universal Merchant AAT-R7GXNZWISTRFA,Amazon PLCC Free-Financing Universal Merchant AAT-WSJLDN3X7KEMO,Amazon PLCC Free-Financing Universal Merchant AAT-VL6FGQVGQVXUS,Amazon PLCC Free-Financing Universal Merchant AAT-EOKPWFWYW7Y6I,Amazon PLCC Free-Financing Universal Merchant AAT-ZYL5UPUNW6T62,Amazon PLCC Free-Financing Universal Merchant AAT-XVPICCHRWDCAI,Amazon PLCC Free-Financing Universal Merchant AAT-ETXQ3XXWMRXBG,Amazon PLCC Free-Financing Universal Merchant AAT-7X3XCTYG64VBE,Amazon PLCC Free-Financing Universal Merchant AAT-7CHGD3WTS3MHM,Amazon PLCC Free-Financing Universal Merchant AAT-26ZDKNME27X42,Amazon PLCC Free-Financing Universal Merchant AAT-4ZF5KN6E4LJK4,Amazon PLCC Free-Financing Universal Merchant AAT-7RCXIKUAX7DDY,Amazon PLCC Free-Financing Universal Merchant AAT-BRSZZ45H6MHAO,Amazon PLCC Free-Financing Universal Merchant AAT-MKLXOOZWQL7GO,Amazon PLCC Free-Financing Universal Merchant AAT-CB7UNXEXGIJTC,Amazon PLCC Free-Financing Universal Merchant #MP-gzasho-1593152694811,Amazon PLCC Free-Financing Universal Merchant AAT-WLBA4GZ52EAH4 | False | Easy Ship | NaN |
| 2 | 2 | 404-0687676-7273146 | 04-30-22 | Shipped | Amazon | Amazon.in | Expedited | JNE3371 | JNE3371-KR-XL | kurta | XL | B07WV4JV4D | Shipped | 1 | INR | 329.00 | NAVI MUMBAI | MAHARASHTRA | 410210.0 | IN | IN Core Free Shipping 2015/04/08 23-48-5-108 | True | NaN | NaN |
| 3 | 3 | 403-9615377-8133951 | 04-30-22 | Cancelled | Merchant | Amazon.in | Standard | J0341 | J0341-DR-L | Western Dress | L | B099NRCT7B | NaN | 0 | INR | 753.33 | PUDUCHERRY | PUDUCHERRY | 605008.0 | IN | NaN | False | Easy Ship | NaN |
| 4 | 4 | 407-1069790-7240320 | 04-30-22 | Shipped | Amazon | Amazon.in | Expedited | JNE3671 | JNE3671-TU-XXXL | Top | 3XL | B098714BZP | Shipped | 1 | INR | 574.00 | CHENNAI | TAMIL NADU | 600073.0 | IN | NaN | False | NaN | NaN |
| 5 | 5 | 404-1490984-4578765 | 04-30-22 | Shipped | Amazon | Amazon.in | Expedited | SET264 | SET264-KR-NP-XL | Set | XL | B08YN7XDSG | Shipped | 1 | INR | 824.00 | GHAZIABAD | UTTAR PRADESH | 201102.0 | IN | IN Core Free Shipping 2015/04/08 23-48-5-108 | False | NaN | NaN |
| 6 | 6 | 408-5748499-6859555 | 04-30-22 | Shipped | Amazon | Amazon.in | Expedited | J0095 | J0095-SET-L | Set | L | B08CMHNWBN | Shipped | 1 | INR | 653.00 | CHANDIGARH | CHANDIGARH | 160036.0 | IN | IN Core Free Shipping 2015/04/08 23-48-5-108 | False | NaN | NaN |
| 7 | 7 | 406-7807733-3785945 | 04-30-22 | Shipped - Delivered to Buyer | Merchant | Amazon.in | Standard | JNE3405 | JNE3405-KR-S | kurta | S | B081WX4G4Q | Shipped | 1 | INR | 399.00 | HYDERABAD | TELANGANA | 500032.0 | IN | Amazon PLCC Free-Financing Universal Merchant AAT-WNKTBO3K27EJC,Amazon PLCC Free-Financing Universal Merchant AAT-QX3UCCJESKPA2,Amazon PLCC Free-Financing Universal Merchant AAT-5QQ7BIYYQEDN2,Amazon PLCC Free-Financing Universal Merchant AAT-DSJ2QRXXWXVMQ,Amazon PLCC Free-Financing Universal Merchant AAT-CXJHMC2YJUK76,Amazon PLCC Free-Financing Universal Merchant AAT-CC4FAVTYR4X7C,Amazon PLCC Free-Financing Universal Merchant AAT-XXRCW6NZEPZI4,Amazon PLCC Free-Financing Universal Merchant AAT-EOKPWFWYW7Y6I,Amazon PLCC Free-Financing Universal Merchant AAT-ZYL5UPUNW6T62,Amazon PLCC Free-Financing Universal Merchant AAT-ETXQ3XXWMRXBG,Amazon PLCC Free-Financing Universal Merchant AAT-7X3XCTYG64VBE,Amazon PLCC Free-Financing Universal Merchant AAT-7CHGD3WTS3MHM,Amazon PLCC Free-Financing Universal Merchant AAT-26ZDKNME27X42,Amazon PLCC Free-Financing Universal Merchant AAT-4ZF5KN6E4LJK4,Amazon PLCC Free-Financing Universal Merchant AAT-7RCXIKUAX7DDY,Amazon PLCC Free-Financing Universal Merchant AAT-BRSZZ45H6MHAO,Amazon PLCC Free-Financing Universal Merchant AAT-MKLXOOZWQL7GO,Amazon PLCC Free-Financing Universal Merchant AAT-CB7UNXEXGIJTC,Amazon PLCC Free-Financing Universal Merchant #MP-gzasho-1593152694811,Amazon PLCC Free-Financing Universal Merchant AAT-WLBA4GZ52EAH4 | False | Easy Ship | NaN |
| 8 | 8 | 407-5443024-5233168 | 04-30-22 | Cancelled | Amazon | Amazon.in | Expedited | SET200 | SET200-KR-NP-A-XXXL | Set | 3XL | B08L91ZZXN | Cancelled | 0 | NaN | NaN | HYDERABAD | TELANGANA | 500008.0 | IN | IN Core Free Shipping 2015/04/08 23-48-5-108 | False | NaN | NaN |
| 9 | 9 | 402-4393761-0311520 | 04-30-22 | Shipped | Amazon | Amazon.in | Expedited | JNE3461 | JNE3461-KR-XXL | kurta | XXL | B08B3XF5MH | Shipped | 1 | INR | 363.00 | Chennai | TAMIL NADU | 600041.0 | IN | NaN | False | NaN | NaN |
| df_index | Order ID | Date | Status | Fulfilment | Sales Channel | ship-service-level | Style | SKU | Category | Size | ASIN | Courier Status | Qty | currency | Amount | ship-city | ship-state | ship-postal-code | ship-country | promotion-ids | B2B | fulfilled-by | Unnamed: 22 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128965 | 128965 | 408-5154281-4593912 | 05-31-22 | Cancelled | Amazon | Amazon.in | Expedited | J0119 | J0119-TP-XXXL | Top | 3XL | B08RYPRVPV | Unshipped | 1 | INR | 574.0 | Prayagraj (ALLAHABAD) | UTTAR PRADESH | 211007.0 | IN | NaN | False | NaN | False |
| 128966 | 128966 | 406-9812666-2474761 | 05-31-22 | Shipped | Amazon | Amazon.in | Expedited | SET224 | SET224-KR-NP-XS | Set | XS | B08MXDBRK1 | Shipped | 1 | INR | 1132.0 | CHENNAI 600042 | TAMIL NADU | 600042.0 | IN | NaN | False | NaN | False |
| 128967 | 128967 | 404-5182288-1653947 | 05-31-22 | Cancelled | Amazon | Amazon.in | Expedited | JNE3638 | JNE3638-KR-XS | kurta | XS | B09814Q3QH | Cancelled | 0 | NaN | NaN | Kolkata | WEST BENGAL | 700040.0 | IN | NaN | False | NaN | False |
| 128968 | 128968 | 403-7059995-7618722 | 05-31-22 | Shipped | Amazon | Amazon.in | Expedited | SET264 | SET264-KR-NP-XL | Set | XL | B08YN7XDSG | Shipped | 1 | INR | 824.0 | Delhi | DELHI | 110053.0 | IN | IN Core Free Shipping 2015/04/08 23-48-5-108 | False | NaN | False |
| 128969 | 128969 | 404-3802633-7250760 | 05-31-22 | Cancelled | Amazon | Amazon.in | Expedited | SET044 | SET044-KR-NP-M | Set | M | B07Q2RTSFB | Unshipped | 1 | INR | 612.0 | MUMBAI | MAHARASHTRA | 400017.0 | IN | NaN | False | NaN | False |
| 128970 | 128970 | 406-6001380-7673107 | 05-31-22 | Shipped | Amazon | Amazon.in | Expedited | JNE3697 | JNE3697-KR-XL | kurta | XL | B098112V2V | Shipped | 1 | INR | 517.0 | HYDERABAD | TELANGANA | 500013.0 | IN | NaN | False | NaN | False |
| 128971 | 128971 | 402-9551604-7544318 | 05-31-22 | Shipped | Amazon | Amazon.in | Expedited | SET401 | SET401-KR-NP-M | Set | M | B09VC6KHX8 | Shipped | 1 | INR | 999.0 | GURUGRAM | HARYANA | 122004.0 | IN | IN Core Free Shipping 2015/04/08 23-48-5-108 | False | NaN | False |
| 128972 | 128972 | 407-9547469-3152358 | 05-31-22 | Shipped | Amazon | Amazon.in | Expedited | J0157 | J0157-DR-XXL | Western Dress | XXL | B0982YZ51B | Shipped | 1 | INR | 690.0 | HYDERABAD | TELANGANA | 500049.0 | IN | NaN | False | NaN | False |
| 128973 | 128973 | 402-6184140-0545956 | 05-31-22 | Shipped | Amazon | Amazon.in | Expedited | J0012 | J0012-SKD-XS | Set | XS | B0894Y2NJQ | Shipped | 1 | INR | 1199.0 | Halol | Gujarat | 389350.0 | IN | IN Core Free Shipping 2015/04/08 23-48-5-108 | False | NaN | False |
| 128974 | 128974 | 408-7436540-8728312 | 05-31-22 | Shipped | Amazon | Amazon.in | Expedited | J0003 | J0003-SET-S | Set | S | B0894X27FC | Shipped | 1 | INR | 696.0 | Raipur | CHHATTISGARH | 492014.0 | IN | IN Core Free Shipping 2015/04/08 23-48-5-108 | False | NaN | False |